﻿<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
    <title>Untitled Page</title>
    <style type="text/css">
        .style1
        {
            color: #FF0000;
            font-weight: bold;
        }
    </style>
</head>
<body>

    <h1>
        Purpose:</h1>
    <ul>
        <li>This application serves the need of transforming one or more Excel files into 
            one or more pipe separated values files and then send them through FTP.</li>
    </ul>
    <h1>
        Decisions:</h1>
    <ul>
        <li>The name of the sheet must bu supplied so I couldn&#39;t just config a Inbox folder 
            and import whatever was inside.</li>
        <li></li>
    </ul>
    <p>
        &nbsp;</p>
    <p>
        &nbsp;</p>
    <h1>
        Configurations:</h1>
    <ul>
        <li>All configurations are inside the applicationtion configuration file.</li>
        <li>Inside the &lt;AppSettings&gt; is the basic configuration related to the location of 
            the needed folders<ul>
                <li>Outbox<ul>
                    <li>Directory where the pipe separated values files are saved to before being sent 
                        through FTP</li>
                    </ul>
                </li>
                <li>Sent<ul>
                    <li>Directory where the files are moved to after being successfully sent through FTP</li>
                    </ul>
                </li>
                <li>DeliveryError<ul>
                    <li>Directory where the files are moved to after being unsuccessfully sent through 
                        FTP</li>
                    </ul>
                </li>
            </ul>
        </li>
        <li>These directories must be configured before running the application.<ul>
            <li>The directory names and paths can be whatever the user want.</li>
            </ul>
        </li>
    </ul>
    <p>
        &nbsp;</p>
    <ul>
        <li>Inside the &lt;ETLConfig&gt; is the specific configuration for the ETL process.<ul>
            <li>&lt;ExcelFilesConfig&gt;<ul>
                <li>Holds the list of excel files to import</li>
                <li>Each line represents one sheet inside one file, if more than one sheets are 
                    needed to import from the same xls the user must add a new line for the same xls 
                    file but pointing to a different sheet.</li>
                </ul>
            </li>
            <li>&lt;FTPConfig&gt;<ul>
                <li>Holds the list of FTP Servers where the files will be copied to</li>
                <li>Be careful with the credentials, be sure to write the correct ip and login 
                    information.<ul>
                        <li class="style1">DO NOT include ftp:// on the IP tag</li>
                    </ul>
                </li>
                </ul>
            </li>
            </ul>
        </li>
    </ul>
    <p>
        &nbsp;</p>

</body>
</html>
